Primary
(
,)
values
(2 + 3) * 4
Trigger conditions can be described by following list of operators, values and functions.
Operator |
Description |
---|---|
|
TRUE if either Boolean expression is TRUE.
Example:
[CommentType] = 'Public' or [Created] < '#01/01/2015#'
|
|
TRUE if both Boolean expression is TRUE.
Example:
[AssignedTo] = '' and [AssignedTo] = [Editor]
|
The and
operator has more priority than the or
.
=
, ==
, !=
, <>
<
, <=
, >
, >=
1 < 2
+
, -
1 + 2 - 5
*
, /
, %
5 * 5
&
(bitwise and), |
(bitwise or), ^
(bitwise xor), <<
(left shift), >>
(right shift)
1 >> 5
!
, not
, -
, ~
(bitwise not)
not true
(
, )
values
(2 + 3) * 4
Operator |
Description |
---|---|
|
Return ticket item before changes.
Example:
([Prev::Status] <> [Status]) and ([Status] == 'Solved')
|
They are represented using numbers.
123456
Use the dot to define the decimal part.
123.456
.123
They are evaluated as Decimal.
You can use the e
to define power of ten (10^).
1.22e1
1e2
1e+2
1e-2
.1e-2
1e10
Must be enclosed between sharps.
#2008/01/31# // for en-US culture
Booleans can be either true
or false
.
true
Any character between single quotes '
are evaluated
as String.
'hello'
You can escape special characters using \\, \’, \n, \r, \t.
A function is made of a name followed by braces, containing optionally any value as arguments.
Abs(1), doSomehting(1, 'dummy')
A parameter as a name, and can be optionally contained inside brackets.
2 + x, 2 + [x]
Name |
Description |
Usage |
Result |
---|---|---|---|
Abs |
Returns the absolute value of a specified number. |
|
|
Acos |
Returns the angle whose cosine is the specified number. |
|
|
Asin |
Returns the angle whose sine is the specified number. |
|
|
Atan |
Returns the angle whose tangent is the specified number. |
|
|
Ceiling |
Returns the smallest integer greater than or equal to the specified number. |
|
|
Cos |
Returns the cosine of the specified angle. |
|
|
Exp |
Returns e raised to the specified power. |
|
|
Floor |
Returns the largest integer less than or equal to the specified number. |
|
|
IEEERemainder |
Returns the remainder resulting from the division of a specified number by another specified number. |
|
|
Log |
Returns the logarithm of a specified number. |
|
|
Log10 |
Returns the base 10 logarithm of a specified number. |
|
|
Max |
Returns the larger of two specified numbers. |
|
|
Min |
Returns the smaller of two numbers. |
|
|
Pow |
Returns a specified number raised to the specified power. |
|
|
Round |
Rounds a value to the nearest integer or specified a number of decimal places. The mid number behavior can be changed by using EvaluateOption.RoundAwayFromZero during construction of the Expression object. |
|
|
Sign |
Returns a value indicating the sign of a number. |
|
|
Sin |
Returns the sine of the specified angle. |
|
|
Sqrt |
Returns the square root of a specified number. |
|
|
Tan |
Returns the tangent of the specified angle. |
|
|
Truncate |
Calculates the integral part of a number. |
|
|
It also includes other general purpose ones.
Name |
Description |
Usage |
Result |
---|---|---|---|
in |
Returns whether an element is in a set of values. |
|
|
if |
Returns a value based on a condition. |
|
|
contains |
Returns true if the first string contains the second. |
|
|
match |
Indicates whether the specified regular expression (second argument) finds a match in the specified input string (first argument). |
|
|